home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Visual Database / Visual dBase v5.5 / CBTSAMP.PAK / ORDERS.QBE < prev    next >
Encoding:
Text File  |  1995-07-18  |  330 b   |  15 lines
  1. * dBASE Windows .QBE file 9
  2. CLOSE DATABASES
  3. SET EXACT ON
  4. SELECT 1
  5. USE ORDERS.DBF ORDER TAG ORDER_NO
  6. SELECT 3
  7. USE CUSTOMER.DBF ORDER TAG CUSTOMER_N
  8. SELECT 2
  9. USE LINEITEM.DBF ORDER TAG ORDER_NO
  10. SELECT 1
  11. SET RELATION TO CUSTOMER_N INTO CUSTOMER, ORDER_NO INTO LINEITEM ;
  12. CONSTRAIN INTEGRITY
  13. SET SKIP TO LINEITEM
  14. GO TOP
  15.